UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8nTPjeVZj8hvlTC/ZOuR1+0s6n7et76qlNOkYvh9MI='
WHERE
key_id = '7f6bdbfaa7ab8a38059d9d9032450558418e30e5a74d2f325be5b4860a24ac07'
AND (
token = 'N8nTPjeVZj8hvlTC/ZOuR1+0s6n7et76qlNOkYvh9MI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)