UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ULRQocgeKM1Nk8YUKMPfQb2HvvxfUOo1CuHC7ztRN9o='
WHERE
key_id = '24e95d1a8ce87a9b30a5622e70b621c9bd29223483343533405656ea40e1a47e'
AND (
token = 'ULRQocgeKM1Nk8YUKMPfQb2HvvxfUOo1CuHC7ztRN9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)