UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yrPiw2Ndoy91MU/PquoK0tkUuMRUYCo4c4r2gU/59fI='
WHERE
key_id = '8dc67530f1c17e17bf32315fec4bbca17d3c782285b00b2f2096be8ff680878b'
AND (
token = 'yrPiw2Ndoy91MU/PquoK0tkUuMRUYCo4c4r2gU/59fI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)