UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mxwTWR99J+/hGBN2zOvuFib1cBVury/yha16QR3xw2w='
WHERE
key_id = 'd0af7c49e1fdb0acd506b5984743b1093e63144b4efbbdbab4a7f9721e7fe609'
AND (
token = 'mxwTWR99J+/hGBN2zOvuFib1cBVury/yha16QR3xw2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)