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