UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KtksW8LS+vVscIz79z53VqcacTJ+Z/d6Q2YBXNMfspo='
WHERE
key_id = 'aef8d72c91d138073869eb7dd0286efabaea1300ea424ecaab9d8fac3537503b'
AND (
token = 'KtksW8LS+vVscIz79z53VqcacTJ+Z/d6Q2YBXNMfspo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)