UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A0fWfvyz3HmGhelHfLtNwTJPyzhvsHI5Rzs8trNdZnA='
WHERE
key_id = 'e7640637af0f7389a9e028f147141c6debcbcc73f95aa3af03dcfea0479605ef'
AND (
token = 'A0fWfvyz3HmGhelHfLtNwTJPyzhvsHI5Rzs8trNdZnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)