UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GLc27GlDWsf7BWNDUV5F8H80s4iC4BR3nYgHySgEtVc='
WHERE
key_id = '835a6ee42421086eb0eb20b2513f1ef19300fc2e34382a7805ee50d6040ee23b'
AND (
token = 'GLc27GlDWsf7BWNDUV5F8H80s4iC4BR3nYgHySgEtVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)