UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDMknd5k4mGuLzFgcEIk86sfFbff4iwIT12d5xsHOdA='
WHERE
key_id = '6e740367c6dd08ddd6a579f666150fb2acf096abfa5779a0430243026d3c4341'
AND (
token = 'ZDMknd5k4mGuLzFgcEIk86sfFbff4iwIT12d5xsHOdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)