UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lq89boZsQdablFd8YF7Wz1I8qYZEi7lYlFdh32HIdmg='
WHERE
key_id = '2d25c22f676112a7e378ef94924f021e326285109b5ddceccd33a96a64120476'
AND (
token = 'lq89boZsQdablFd8YF7Wz1I8qYZEi7lYlFdh32HIdmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)