UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gUoSn0waEcieOScYrBqKDmO+tra8erbENT8TcP6jwLY='
WHERE
key_id = 'a6d24a8faaea14a606fc2ff8d5af2b69673dafacba46c56b2be9c9b78dd14e0a'
AND (
token = 'gUoSn0waEcieOScYrBqKDmO+tra8erbENT8TcP6jwLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)