UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vhKjzxCY61KI7LWyzRHIU7tf6gszHBWG+iAqlXSSq98='
WHERE
key_id = 'e43e8c219aaf21a747d8fd449f489025f417c23ff518a09b408ea404310a9942'
AND (
token = 'vhKjzxCY61KI7LWyzRHIU7tf6gszHBWG+iAqlXSSq98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)