UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LNh8YhxIdh6cEvfijT3Rhp0IhUvaS/LHXV/1BN5dkBM='
WHERE
key_id = 'bca3e3fc6f5f6b9a4dc979c0e1693a6a733f8b797ca3786c09340267b06e6efc'
AND (
token = 'LNh8YhxIdh6cEvfijT3Rhp0IhUvaS/LHXV/1BN5dkBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)