UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r50jLvfXGGu2sYixhPA5XNJvZru6HVfozLFf8YG9kh0='
WHERE
key_id = '169f37f121187a3a2c52c7dfb6e146761296b4258336ee19005f2b50730e3cdd'
AND (
token = 'r50jLvfXGGu2sYixhPA5XNJvZru6HVfozLFf8YG9kh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)