UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTX9iHArdwJb2umbuzTR/U2seSp3u16ldwU3g3jZA/M='
WHERE
key_id = '6c38fc7545dd33c42ea04b5ae2fbfa39a843a253f8406621fb5a6663bf8a7f53'
AND (
token = 'ZTX9iHArdwJb2umbuzTR/U2seSp3u16ldwU3g3jZA/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)