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