UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'apSXRZM2rpRsV1mH/hoCFqAIp5ZI3i3AWdhPN3qpwmg='
WHERE
key_id = 'ebf685c5f8d7862f867afd7fa1b273e15d5bd1e5f035f106e523448f5e61f3c5'
AND (
token = 'apSXRZM2rpRsV1mH/hoCFqAIp5ZI3i3AWdhPN3qpwmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)