UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTQh+0qitwrZjj0mJfoIDc1DDG3gt/Uwqk7fgTGlnEg='
WHERE
key_id = 'd468010587a05d00bce148c79fe8122809e6b87ef60c750be53b761776e61227'
AND (
token = 'HTQh+0qitwrZjj0mJfoIDc1DDG3gt/Uwqk7fgTGlnEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)