UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7435lgIpcUTffIN2Rs+LaC9pOs+BXO3932a5FAP12E='
WHERE
key_id = '6bb77fc11ce500d6c472a9aaaec730f94a360ee37de7833234dd0d76431fc2f9'
AND (
token = 'G7435lgIpcUTffIN2Rs+LaC9pOs+BXO3932a5FAP12E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)