UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWvkLSbQsAJuMNp9gtWx4I6VItDuxlOd6sDn0xfMYL8='
WHERE
key_id = '052b3aaf35e40c27df75d116b821d52d114f7f30d822856b023bd1ea4689a3a1'
AND (
token = 'VWvkLSbQsAJuMNp9gtWx4I6VItDuxlOd6sDn0xfMYL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)