UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'knkcACFxu6RjX61CN70TDHFKxpD0i41iSs4VpoDj79g='
WHERE
key_id = 'e5ff81ff7fffeb3223829ce141f4308c203ba98689ce6eb257dea3a77c28a8f2'
AND (
token = 'knkcACFxu6RjX61CN70TDHFKxpD0i41iSs4VpoDj79g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)