UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bbwZ5dckCOiIEIKJUNhX9Gdbc9wq0fUQDSH4JHgTdys='
WHERE
key_id = '1a371babcc8a2bba2f11e1aad9cc247f7788d0cb1b0710af4bada403f332dd5e'
AND (
token = 'bbwZ5dckCOiIEIKJUNhX9Gdbc9wq0fUQDSH4JHgTdys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)