UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yA6bA8IXCp/5YBqua1iwnOIHDlqoc4c0Km0LgfnjhdI='
WHERE
key_id = 'f8242c23363e7a29e6606f4508629f65ba522340e14eaed9c8e349fdbb5e2172'
AND (
token = 'yA6bA8IXCp/5YBqua1iwnOIHDlqoc4c0Km0LgfnjhdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)