UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9yfxzGe6N0lqK9R0afCgu0KJIANY8UOsPeIvJk8mD8='
WHERE
key_id = '3fb5505700db9647b0bd4d85d5d977b8c8190d2c3b721d868b4e60db9295ce41'
AND (
token = 'd9yfxzGe6N0lqK9R0afCgu0KJIANY8UOsPeIvJk8mD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)