UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '18e7FaqC50cjN3oiG66hxRNk9yrB5vPbUzCh1iEX1iE='
WHERE
key_id = '44e61d11f2ad871bef654108e966b3a083e9ad3464274a6006580a33a08d8ee0'
AND (
token = '18e7FaqC50cjN3oiG66hxRNk9yrB5vPbUzCh1iEX1iE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)