UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qBJRV802kQe2WE0dF0DA4gWX1A7BgZzpK5k/F62P9BE='
WHERE
key_id = 'c858c67e4c152470961d143591b58b047c1c62e042f316a08eb6eb371191c734'
AND (
token = 'qBJRV802kQe2WE0dF0DA4gWX1A7BgZzpK5k/F62P9BE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)