UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ob8opUwwdzsrorAeDaVboodrHnILoKO7ALG5vciSSo='
WHERE
key_id = '29a1bdc6313ca11d50434c8b7ee19a28c4f74d8ce09b3da0e6ab59a6a45a2bda'
AND (
token = '5ob8opUwwdzsrorAeDaVboodrHnILoKO7ALG5vciSSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)