UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2V0FufWZCGdoj48vzf1lF3tHPRenUZqq1zlp6mLuKwo='
WHERE
key_id = 'ec963aab58be703d2418ca34cfb507d6c3c6a2883e003d0b05de9c7fd89dcef1'
AND (
token = '2V0FufWZCGdoj48vzf1lF3tHPRenUZqq1zlp6mLuKwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)