UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sB/JS9yBp4QjB874U06oKZSbDCAxWMaar4pZkGl833Y='
WHERE
key_id = 'a0a55eba38c73d33277efff009ba968e1a1c2375eaf02837eb5cfa8c4be0cd35'
AND (
token = 'sB/JS9yBp4QjB874U06oKZSbDCAxWMaar4pZkGl833Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)