UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mi4lBcDS8YLZXSf8vtUcaV5RIEW+w/ji5fgKHkVQZ4Q='
WHERE
key_id = '7957a9c9527f7b8de894d03ec3867b10451b838d2a175be399ac6e04741b0783'
AND (
token = 'Mi4lBcDS8YLZXSf8vtUcaV5RIEW+w/ji5fgKHkVQZ4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)