UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TD/ZFKW34g1/mYD4ZIcO8CpNcxCMpmTSVnmD269jEd0='
WHERE
key_id = 'd024c5f11e4ba596a70c00d23fd43c27c408a6864212f8579d719b324decfb49'
AND (
token = 'TD/ZFKW34g1/mYD4ZIcO8CpNcxCMpmTSVnmD269jEd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)