UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/7c5zUA41tOV3wyvq9Rjs155RjRtj3PK9a1qXebD3ng='
WHERE
key_id = 'b11af5ac387e2ed4551b35be3ad4bb0fb861e0ed2699f407d2a01e357576df04'
AND (
token = '/7c5zUA41tOV3wyvq9Rjs155RjRtj3PK9a1qXebD3ng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)