UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBJ7/8dzpBIz0EE47dTmZQQa7kI4XJ2ncsa1eVBkhjs='
WHERE
key_id = '1139c496a2f52fbafe1755c4ce1ddf57d934ace7ab8d5b3be98aad9f72cb5d86'
AND (
token = 'HBJ7/8dzpBIz0EE47dTmZQQa7kI4XJ2ncsa1eVBkhjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)