UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '//G+SZN9j3XCemi7shf8q2y4HNR3b+aDPomD7omEeJE='
WHERE
key_id = 'ac1e98e5ec469fd20a88dd0e2c513ec16ef3da01b2131aa97180359756a7528f'
AND (
token = '//G+SZN9j3XCemi7shf8q2y4HNR3b+aDPomD7omEeJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)